# import pymysql  # pymysql 三方库连接数据库
# db = pymysql.connect(user='root',password='123456',host='8.136.106.114',database='zuoye',cursorclass =
# pymysql.cursors.DictCursor)    # 登录
# cursor = db.cursor()
# cursor.execute('select * from student')  #查看表
# result = cursor.fetchone() #查一次
# print(result)
# # result = cursor.fetchall() #查全部
# # print(result)
# for line in result:  #一条一条的显示
#     print(line)
# cursor.execute("insert into student(name,phone,address) values('张三','12352','黑山')")  #增加

from faker import Faker



